/*
 * Copyright (c) 2007, Justin R. Akehurst
 *
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without modification, 
 * are permitted provided that the following conditions are met:
 *
 *  * Redistributions of source code must retain the above copyright notice, this 
 *    list of conditions and the following disclaimer.
 *  * Redistributions in binary form must reproduce the above copyright notice, this 
 *    list of conditions and the following disclaimer in the documentation and/or other 
 *    materials provided with the distribution.
 *  * Neither the name of Poindextrose nor the names of its contributors may be 
 *    used to endorse or promote products derived from this software without specific 
 *    prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
 * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
 * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
 * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
 * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
 * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
 * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */
package org.poindextrose.ant;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.apache.tools.ant.BuildException;
import org.apache.tools.ant.taskdefs.JDBCTask;

public class SqlPropertyTask extends JDBCTask {

    private String propertyName = null;
    private String propertyValue = null;

    /**
     * SQL input command
     */
    private String sqlCommand = null;

    /**
     * Set the name of the property that output will be set. Required.
     * 
     * @param propertyName
     *            The name of the property.
     */
    public void setPropertyName(String propertyName) {
        this.propertyName = propertyName;
    }

    public void setSql(String sql) {
        this.sqlCommand = sql;
    }

    public void execute() throws BuildException {
        if (propertyName == null) {
            throw new BuildException("PropertyName must be specified");
        }

        if (sqlCommand == null) {
            throw new BuildException("Sql must be specified");
        }

        Connection conn = getConnection();
        Statement stmt = null;
        try {
            stmt = conn.createStatement();

            // we only need the first row
            stmt.setMaxRows(1);

            ResultSet rs = stmt.executeQuery(sqlCommand);
            if (rs.next()) {
                propertyValue = rs.getObject(1).toString();
            }
        } catch (SQLException e) {

        } finally {
            if (stmt != null) {
                try {
                    stmt.close();
                } catch (SQLException ignore) {
                }
            }
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException ignore) {
                }
            }
        }
        
        if (propertyValue == null) {
            propertyValue = "NOT SET";
        }
        
        // set our property
        getProject().setNewProperty(propertyName, propertyValue);
    }
}
